SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_GetCompanyName]
	
	(
	@param_userID VARCHAR(50)

	)
	
AS
	/* SET NOCOUNT ON */
	
	SELECT JOL_Employer_No,JOL_Employer_Name FROM dbo.JOL_Employer WHERE  JOL_Employer_Account=@param_userID
	RETURN
GO
